class AddingRoutes < ActiveRecord::Migration
  def self.up
  
    create_table "routes", :force => true do |t|
      t.column "name", :string, :limit => 40, :default => "", :null => false
      t.column "description", :text
      t.column "created_on", :datetime
      t.column "updated_on", :datetime
    end
    
    execute "ALTER TABLE rides ADD COLUMN route_id int( 11 ) NOT NULL AFTER average_speed"
    
  end

  def self.down
  end
end
